﻿using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace PMQUANLYPHONGMAY
{
    public partial class UcChitTietHoaDonBoSung : UserControl
    {
        public UcChitTietHoaDonBoSung()
        {
            InitializeComponent();
        }
        SqlConnection conn = new SqlConnection(@"server = DESKTOP-N8SB9L7\SQLEXPRESS; database = QUANLYPHONGMAY; Trusted_Connection = true");
        SqlDataAdapter da_bosungtb;
        DataTable dt_bosungtb;
        SqlCommand command;

        private void UcBosungTrangthietbi_Load(object sender, EventArgs e)
        {
            conn.Open();
            string command = "EXECUTE select_chitiethoadonmuabosung";
            da_bosungtb = new SqlDataAdapter(command, conn);
            dt_bosungtb = new DataTable();
            da_bosungtb.Fill(dt_bosungtb);
            dgv_bosungtb.DataSource = dt_bosungtb;
            conn.Close();
        }

    } 
}
